Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	4320
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	472.6 KiB
Average record size in memory	112.0 B

Variable types

Numeric	14

Alerts

`lifetime` is highly overall correlated with `purchase_count`	High correlation
`recency` is highly overall correlated with `avg_purchase_interval` and 2 other fields	High correlation
`avg_purchase_interval` is highly overall correlated with `recency` and 2 other fields	High correlation
`frequency` is highly overall correlated with `recency` and 2 other fields	High correlation
`number_products` is highly overall correlated with `nunique_products` and 2 other fields	High correlation
`nunique_products` is highly overall correlated with `number_products` and 2 other fields	High correlation
`avg_basket_size` is highly overall correlated with `avg_order_value` and 1 other fields	High correlation
`purchase_count` is highly overall correlated with `lifetime` and 8 other fields	High correlation
`charge_back_count` is highly overall correlated with `purchase_count` and 1 other fields	High correlation
`return_rate` is highly overall correlated with `purchase_count` and 1 other fields	High correlation
`avg_order_value` is highly overall correlated with `avg_basket_size` and 1 other fields	High correlation
`gross_revenue` is highly overall correlated with `number_products` and 4 other fields	High correlation
`avg_unt_price` is highly skewed (γ1 = 36.54224156)	Skewed
`gross_revenue` is highly skewed (γ1 = 21.5077176)	Skewed
`customer_id` has unique values	Unique
`charge_back_count` has 2828 (65.5%) zeros	Zeros
`return_rate` has 2828 (65.5%) zeros	Zeros

Reproduction

Analysis started	2023-05-29 18:33:12.610778
Analysis finished	2023-05-29 18:33:46.608470
Duration	34 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	4320
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15300.771

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	12347
5-th percentile	12617.95
Q1	13815.75
median	15299.5
Q3	16778.25
95-th percentile	17980.2
Maximum	18287
Range	5940
Interquartile range (IQR)	2962.5

Descriptive statistics

Standard deviation	1720.2179
Coefficient of variation (CV)	0.11242688
Kurtosis	-1.1947082
Mean	15300.771
Median Absolute Deviation (MAD)	1481
Skewness	0.0010717092
Sum	66099331
Variance	2959149.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
15280	1	< 0.1%
15700	1	< 0.1%
17299	1	< 0.1%
12837	1	< 0.1%
15076	1	< 0.1%
17444	1	< 0.1%
15921	1	< 0.1%
15747	1	< 0.1%
15840	1	< 0.1%
Other values (4310)	4310	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%

lifetime
Real number (ℝ)

Distinct	305
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	223.07708

Minimum	0
Maximum	373
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	113
median	249
Q3	326
95-th percentile	371
Maximum	373
Range	373
Interquartile range (IQR)	213

Descriptive statistics

Standard deviation	117.7561
Coefficient of variation (CV)	0.52787178
Kurtosis	-1.2272183
Mean	223.07708
Median Absolute Deviation (MAD)	102
Skewness	-0.36980487
Sum	963693
Variance	13866.499
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
373	95	2.2%
372	91	2.1%
366	83	1.9%
368	70	1.6%
369	69	1.6%
365	67	1.6%
358	58	1.3%
367	50	1.2%
371	46	1.1%
359	42	1.0%
Other values (295)	3649	84.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	4	0.1%
2	5	0.1%
3	9	0.2%
4	7	0.2%
5	5	0.1%
7	6	0.1%
8	3	0.1%
9	5	0.1%
10	12	0.3%

Value	Count	Frequency (%)
373	95	2.2%
372	91	2.1%
371	46	1.1%
369	69	1.6%
368	70	1.6%
367	50	1.2%
366	83	1.9%
365	67	1.6%
364	40	0.9%
362	31	0.7%

recency
Real number (ℝ)

Distinct	304
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.013657

Minimum	0
Maximum	373
Zeros	35
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	17
median	50
Q3	142
95-th percentile	311
Maximum	373
Range	373
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	100.06908
Coefficient of variation (CV)	1.0875459
Kurtosis	0.43240872
Mean	92.013657
Median Absolute Deviation (MAD)	40
Skewness	1.2467806
Sum	397499
Variance	10013.82
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	103	2.4%
4	94	2.2%
3	94	2.2%
2	90	2.1%
8	79	1.8%
10	77	1.8%
17	74	1.7%
7	71	1.6%
9	70	1.6%
22	64	1.5%
Other values (294)	3504	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35	0.8%
1	103	2.4%
2	90	2.1%
3	94	2.2%
4	94	2.2%
5	48	1.1%
7	71	1.6%
8	79	1.8%
9	70	1.6%
10	77	1.8%

Value	Count	Frequency (%)
373	17	0.4%
372	17	0.4%
371	6	0.1%
369	3	0.1%
368	5	0.1%
367	5	0.1%
366	10	0.2%
365	10	0.2%
364	6	0.1%
362	6	0.1%

avg_purchase_interval
Real number (ℝ)

Distinct	1402
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	89.597846

Minimum	0
Maximum	373
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	11.736549
Q1	31
median	60
Q3	119
95-th percentile	289.05
Maximum	373
Range	373
Interquartile range (IQR)	88

Descriptive statistics

Standard deviation	84.740189
Coefficient of variation (CV)	0.94578377
Kurtosis	2.0189487
Mean	89.597846
Median Absolute Deviation (MAD)	34
Skewness	1.6162457
Sum	387062.7
Variance	7180.8996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53	31	0.7%
30	26	0.6%
25	23	0.5%
106	21	0.5%
18	21	0.5%
64	20	0.5%
23	19	0.4%
29	19	0.4%
43	19	0.4%
92	18	0.4%
Other values (1392)	4103	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.6666666667	1	< 0.1%
1	5	0.1%
1.534979424	1	< 0.1%
1.718894009	1	< 0.1%
2	3	0.1%
2.207100592	1	< 0.1%
2.25	1	< 0.1%
2.5	1	< 0.1%
2.96031746	1	< 0.1%

Value	Count	Frequency (%)
373	15	0.3%
372	14	0.3%
371	5	0.1%
369	1	< 0.1%
368	4	0.1%
367	5	0.1%
366	6	0.1%
365	8	0.2%
364	5	0.1%
362	6	0.1%

frequency
Real number (ℝ)

Distinct	1402
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.029348771

Minimum	0
Maximum	1.5
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0034482759
Q1	0.0084033613
median	0.016666667
Q3	0.032258065
95-th percentile	0.085110323
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.023854703

Descriptive statistics

Standard deviation	0.056479631
Coefficient of variation (CV)	1.9244292
Kurtosis	219.29335
Mean	0.029348771
Median Absolute Deviation (MAD)	0.0098820059
Skewness	12.05582
Sum	126.78669
Variance	0.0031899487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01886792453	31	0.7%
0.03333333333	26	0.6%
0.04	23	0.5%
0.009433962264	21	0.5%
0.05555555556	21	0.5%
0.015625	20	0.5%
0.04347826087	19	0.4%
0.03448275862	19	0.4%
0.02325581395	19	0.4%
0.01086956522	18	0.4%
Other values (1392)	4103	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.002680965147	15	0.3%
0.002688172043	14	0.3%
0.00269541779	5	0.1%
0.0027100271	1	< 0.1%
0.002717391304	4	0.1%
0.00272479564	5	0.1%
0.002732240437	6	0.1%
0.002739726027	8	0.2%
0.002747252747	5	0.1%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1	5	0.1%
0.6514745308	1	< 0.1%
0.581769437	1	< 0.1%
0.5	3	0.1%
0.4530831099	1	< 0.1%
0.4444444444	1	< 0.1%
0.4	1	< 0.1%
0.3378016086	1	< 0.1%
0.3333333333	10	0.2%

number_products
Real number (ℝ)

Distinct	468
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.728241

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	41
Q3	100
95-th percentile	315.05
Maximum	7838
Range	7837
Interquartile range (IQR)	83

Descriptive statistics

Standard deviation	228.81283
Coefficient of variation (CV)	2.4944643
Kurtosis	482.47675
Mean	91.728241
Median Absolute Deviation (MAD)	30
Skewness	18.091345
Sum	396266
Variance	52355.309
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	85	2.0%
6	77	1.8%
9	75	1.7%
1	70	1.6%
15	69	1.6%
11	68	1.6%
8	67	1.6%
5	66	1.5%
7	65	1.5%
28	65	1.5%
Other values (458)	3613	83.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	70	1.6%
2	50	1.2%
3	56	1.3%
4	48	1.1%
5	66	1.5%
6	77	1.8%
7	65	1.5%
8	67	1.6%
9	75	1.7%
10	85	2.0%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

nunique_products
Real number (ℝ)

Distinct	341
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.584954

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	16
median	35
Q3	77.25
95-th percentile	204
Maximum	1786
Range	1785
Interquartile range (IQR)	61.25

Descriptive statistics

Standard deviation	85.403084
Coefficient of variation (CV)	1.3867524
Kurtosis	99.614722
Mean	61.584954
Median Absolute Deviation (MAD)	24
Skewness	6.9167284
Sum	266047
Variance	7293.6867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	91	2.1%
10	85	2.0%
8	80	1.9%
9	79	1.8%
11	76	1.8%
13	76	1.8%
6	73	1.7%
5	72	1.7%
15	72	1.7%
14	72	1.7%
Other values (331)	3544	82.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	91	2.1%
2	51	1.2%
3	60	1.4%
4	51	1.2%
5	72	1.7%
6	73	1.7%
7	71	1.6%
8	80	1.9%
9	79	1.8%
10	85	2.0%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
817	1	< 0.1%
717	1	< 0.1%
714	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

avg_basket_size
Real number (ℝ)

Distinct	2243
Distinct (%)	51.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	200.08462

Minimum	0.25
Maximum	7824
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0.25
5-th percentile	30
Q1	80
median	140
Q3	236.15833
95-th percentile	524.01667
Maximum	7824
Range	7823.75
Interquartile range (IQR)	156.15833

Descriptive statistics

Standard deviation	269.78265
Coefficient of variation (CV)	1.3483427
Kurtosis	193.52202
Mean	200.08462
Median Absolute Deviation (MAD)	70.630682
Skewness	10.017756
Sum	864365.58
Variance	72782.679
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	19	0.4%
72	18	0.4%
64	17	0.4%
144	16	0.4%
136	16	0.4%
44	16	0.4%
60	15	0.3%
146	15	0.3%
100	15	0.3%
88	15	0.3%
Other values (2233)	4158	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.25	1	< 0.1%
0.6666666667	1	< 0.1%
1	2	< 0.1%
2	4	0.1%
3	4	0.1%
3.333333333	1	< 0.1%
4	7	0.2%
5	3	0.1%
5.25	1	< 0.1%
5.5	1	< 0.1%

Value	Count	Frequency (%)
7824	1	< 0.1%
4300	1	< 0.1%
4280	1	< 0.1%
3206.083333	1	< 0.1%
3028	1	< 0.1%
2924	1	< 0.1%
2880	1	< 0.1%
2708	1	< 0.1%
2692.547945	1	< 0.1%
2529	1	< 0.1%

purchase_count
Real number (ℝ)

Distinct	63
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.0310185

Minimum	1
Maximum	243
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	5
95-th percentile	16
Maximum	243
Range	242
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.1323251
Coefficient of variation (CV)	1.815204
Kurtosis	222.19401
Mean	5.0310185
Median Absolute Deviation (MAD)	2
Skewness	11.431686
Sum	21734
Variance	83.399362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1301	30.1%
2	800	18.5%
3	488	11.3%
4	381	8.8%
5	282	6.5%
6	195	4.5%
7	152	3.5%
8	117	2.7%
9	80	1.9%
10	73	1.7%
Other values (53)	451	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1301	30.1%
2	800	18.5%
3	488	11.3%
4	381	8.8%
5	282	6.5%
6	195	4.5%
7	152	3.5%
8	117	2.7%
9	80	1.9%
10	73	1.7%

Value	Count	Frequency (%)
243	1	< 0.1%
217	1	< 0.1%
169	1	< 0.1%
126	1	< 0.1%
118	2	< 0.1%
88	1	< 0.1%
75	1	< 0.1%
73	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%

charge_back_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.77199074

Minimum	0
Maximum	45
Zeros	2828
Zeros (%)	65.5%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.9735699
Coefficient of variation (CV)	2.5564684
Kurtosis	151.42598
Mean	0.77199074
Median Absolute Deviation (MAD)	0
Skewness	9.1742875
Sum	3335
Variance	3.8949782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	2828	65.5%
1	839	19.4%
2	288	6.7%
3	139	3.2%
4	92	2.1%
5	37	0.9%
6	32	0.7%
7	21	0.5%
9	8	0.2%
10	5	0.1%
Other values (13)	31	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2828	65.5%
1	839	19.4%
2	288	6.7%
3	139	3.2%
4	92	2.1%
5	37	0.9%
6	32	0.7%
7	21	0.5%
8	5	0.1%
9	8	0.2%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	0.1%

return_rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	143
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.099820228

Minimum	0
Maximum	0.75
Zeros	2828
Zeros (%)	65.5%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.2
95-th percentile	0.5
Maximum	0.75
Range	0.75
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.16131425
Coefficient of variation (CV)	1.6160478
Kurtosis	1.0390432
Mean	0.099820228
Median Absolute Deviation (MAD)	0
Skewness	1.4736402
Sum	431.22338
Variance	0.026022289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2828	65.5%
0.5	234	5.4%
0.3333333333	211	4.9%
0.25	165	3.8%
0.2	139	3.2%
0.1666666667	78	1.8%
0.1428571429	61	1.4%
0.4	55	1.3%
0.125	46	1.1%
0.2857142857	40	0.9%
Other values (133)	463	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2828	65.5%
0.01369863014	1	< 0.1%
0.02222222222	1	< 0.1%
0.02272727273	1	< 0.1%
0.02631578947	1	< 0.1%
0.02857142857	1	< 0.1%
0.0303030303	1	< 0.1%
0.03225806452	1	< 0.1%
0.03333333333	1	< 0.1%
0.03448275862	1	< 0.1%

Value	Count	Frequency (%)
0.75	1	< 0.1%
0.7142857143	1	< 0.1%
0.6666666667	18	0.4%
0.6	13	0.3%
0.5714285714	5	0.1%
0.5555555556	2	< 0.1%
0.5454545455	2	< 0.1%
0.5	234	5.4%
0.4736842105	1	< 0.1%
0.4615384615	4	0.1%

avg_unt_price
Real number (ℝ)

Distinct	4173
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4633073

Minimum	0.1225
Maximum	434.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0.1225
5-th percentile	1.3236833
Q1	2.1573676
median	2.8290222
Q3	3.7120688
95-th percentile	5.9766905
Maximum	434.65
Range	434.5275
Interquartile range (IQR)	1.5547011

Descriptive statistics

Standard deviation	8.875852
Coefficient of variation (CV)	2.5628255
Kurtosis	1578.4644
Mean	3.4633073
Median Absolute Deviation (MAD)	0.74558104
Skewness	36.542242
Sum	14961.487
Variance	78.780749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.06	10	0.2%
1.79	8	0.2%
4.95	7	0.2%
2.08	7	0.2%
1.25	6	0.1%
2.55	6	0.1%
2.95	6	0.1%
12.75	4	0.1%
4.25	4	0.1%
0.72	4	0.1%
Other values (4163)	4258	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1225	1	< 0.1%
0.17	2	< 0.1%
0.2327777778	1	< 0.1%
0.29	2	< 0.1%
0.32	1	< 0.1%
0.358	1	< 0.1%
0.3666666667	1	< 0.1%
0.39	1	< 0.1%
0.3917241379	1	< 0.1%
0.39375	1	< 0.1%

Value	Count	Frequency (%)
434.65	1	< 0.1%
295	1	< 0.1%
125	1	< 0.1%
110	2	< 0.1%
74.975	1	< 0.1%
66.475	1	< 0.1%
59.73333333	1	< 0.1%
54.3	1	< 0.1%
51.71	1	< 0.1%
32.97142857	1	< 0.1%

avg_order_value
Real number (ℝ)

Distinct	4250
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	326.33512

Minimum	0.96666667
Maximum	9904.875
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	0.96666667
5-th percentile	76.497444
Q1	154.895
median	240.79536
Q3	372.115
95-th percentile	775.86938
Maximum	9904.875
Range	9903.9083
Interquartile range (IQR)	217.22

Descriptive statistics

Standard deviation	390.52051
Coefficient of variation (CV)	1.1966855
Kurtosis	136.13431
Mean	326.33512
Median Absolute Deviation (MAD)	100.78464
Skewness	8.8462255
Sum	1409767.7
Variance	152506.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	4	0.1%
76.32	4	0.1%
113.5	3	0.1%
15	3	0.1%
197.9	3	0.1%
35.4	3	0.1%
440	3	0.1%
72	2	< 0.1%
142.4	2	< 0.1%
357.21	2	< 0.1%
Other values (4240)	4291	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.9666666667	1	< 0.1%
3.75	2	< 0.1%
5.9	1	< 0.1%
6.12	1	< 0.1%
9.14	1	< 0.1%
11.67	1	< 0.1%
12.75	1	< 0.1%
15	3	0.1%
17	1	< 0.1%
20.475	1	< 0.1%

Value	Count	Frequency (%)
9904.875	1	< 0.1%
6207.67	1	< 0.1%
5383.975	1	< 0.1%
5151.590833	1	< 0.1%
4873.81	1	< 0.1%
4669.19	1	< 0.1%
4366.78	1	< 0.1%
4327.621667	1	< 0.1%
4314.72	1	< 0.1%
4131.233333	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	4245
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1920.743

Minimum	2.9
Maximum	278778.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.9 KiB

Quantile statistics

Minimum	2.9
5-th percentile	110.7975
Q1	300.845
median	654.76
Q3	1611.4325
95-th percentile	5657.141
Maximum	278778.02
Range	278775.12
Interquartile range (IQR)	1310.5875

Descriptive statistics

Standard deviation	8320.8119
Coefficient of variation (CV)	4.3320798
Kurtosis	595.75815
Mean	1920.743
Median Absolute Deviation (MAD)	453.69
Skewness	21.507718
Sum	8297609.7
Variance	69235911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
76.32	4	0.1%
440	3	0.1%
35.4	3	0.1%
15	3	0.1%
113.5	3	0.1%
363.65	3	0.1%
144	2	< 0.1%
161	2	< 0.1%
598.2	2	< 0.1%
248.61	2	< 0.1%
Other values (4235)	4293	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.9	1	< 0.1%
3.75	1	< 0.1%
5.9	1	< 0.1%
12.24	1	< 0.1%
12.75	1	< 0.1%
15	3	0.1%
17	1	< 0.1%
20.8	2	< 0.1%
25.5	1	< 0.1%
30	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
133007.13	1	< 0.1%
123638.18	1	< 0.1%
114505.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	customer_id	lifetime	recency	avg_purchase_interval	frequency	number_products	nunique_products	avg_basket_size	purchase_count	charge_back_count	return_rate	avg_unt_price	avg_order_value	gross_revenue
customer_id	1.000	0.004	0.006	-0.001	0.002	-0.005	-0.009	-0.087	-0.013	-0.044	-0.051	-0.018	-0.105	-0.079
lifetime	0.004	1.000	0.105	0.287	-0.285	0.344	0.300	-0.053	0.514	0.307	0.221	0.094	0.001	0.398
recency	0.006	0.105	1.000	0.764	-0.763	-0.499	-0.456	-0.151	-0.536	-0.272	-0.171	0.097	-0.115	-0.485
avg_purchase_interval	-0.001	0.287	0.764	1.000	-0.999	-0.462	-0.416	-0.116	-0.550	-0.443	-0.357	0.077	-0.076	-0.471
frequency	0.002	-0.285	-0.763	-0.999	1.000	0.462	0.416	0.114	0.551	0.443	0.358	-0.076	0.075	0.470
number_products	-0.005	0.344	-0.499	-0.462	0.462	1.000	0.983	0.385	0.716	0.411	0.293	-0.084	0.381	0.788
nunique_products	-0.009	0.300	-0.456	-0.416	0.416	0.983	1.000	0.395	0.642	0.374	0.273	-0.081	0.383	0.734
avg_basket_size	-0.087	-0.053	-0.151	-0.116	0.114	0.385	0.395	1.000	0.057	-0.050	-0.094	-0.400	0.817	0.512
purchase_count	-0.013	0.514	-0.536	-0.550	0.551	0.716	0.642	0.057	1.000	0.667	0.557	0.026	0.061	0.801
charge_back_count	-0.044	0.307	-0.272	-0.443	0.443	0.411	0.374	-0.050	0.667	1.000	0.958	0.080	-0.052	0.482
return_rate	-0.051	0.221	-0.171	-0.357	0.358	0.293	0.273	-0.094	0.557	0.958	1.000	0.087	-0.103	0.362
avg_unt_price	-0.018	0.094	0.097	0.077	-0.076	-0.084	-0.081	-0.400	0.026	0.080	0.087	1.000	0.002	0.021
avg_order_value	-0.105	0.001	-0.115	-0.076	0.075	0.381	0.383	0.817	0.061	-0.052	-0.103	0.002	1.000	0.611
gross_revenue	-0.079	0.398	-0.485	-0.471	0.470	0.788	0.734	0.512	0.801	0.482	0.362	0.021	0.611	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	lifetime	recency	avg_purchase_interval	frequency	number_products	nunique_products	avg_basket_size	purchase_count	charge_back_count	return_rate	avg_unt_price	avg_order_value	gross_revenue
0	17850.0	373.0	372.0	10.657143	0.093834	297.0	21.0	48.371429	35	1.0	0.028571	3.960370	151.103714	5288.63
1	13047.0	373.0	56.0	23.312500	0.042895	171.0	105.0	84.687500	16	7.0	0.437500	3.926082	193.068750	3089.10
2	12583.0	373.0	2.0	21.941176	0.045576	232.0	114.0	292.823529	17	2.0	0.117647	2.140474	389.961176	6629.34
3	13748.0	373.0	95.0	74.600000	0.013405	28.0	24.0	87.800000	5	0.0	0.000000	3.996429	189.650000	948.25
4	15100.0	373.0	333.0	62.166667	0.016086	3.0	1.0	9.666667	6	3.0	0.500000	10.950000	105.850000	635.10
5	15291.0	373.0	25.0	19.631579	0.050938	102.0	61.0	109.105263	19	5.0	0.263158	4.702255	239.553158	4551.51
6	14688.0	373.0	7.0	13.814815	0.072386	327.0	148.0	119.333333	27	6.0	0.222222	2.131040	189.162222	5107.38
7	17809.0	373.0	16.0	26.642857	0.037534	61.0	46.0	144.000000	14	2.0	0.142857	2.905738	381.775000	5344.85
8	15311.0	373.0	0.0	3.161017	0.316354	2379.0	567.0	319.661017	118	27.0	0.228814	2.506036	503.553729	59419.34
9	16098.0	373.0	87.0	53.285714	0.018767	67.0	34.0	87.571429	7	0.0	0.000000	4.424627	286.518571	2005.63

	customer_id	lifetime	recency	avg_purchase_interval	frequency	number_products	nunique_products	avg_basket_size	purchase_count	charge_back_count	return_rate	avg_unt_price	avg_order_value	gross_revenue
4310	16000.0	2.0	2.0	0.666667	1.5	9.0	9.0	1703.333333	3	0.0	0.0	3.345556	4131.233333	12393.70
4311	15195.0	2.0	2.0	2.000000	0.5	1.0	1.0	1404.000000	1	0.0	0.0	2.750000	3861.000000	3861.00
4312	14087.0	2.0	2.0	1.000000	1.0	69.0	61.0	125.000000	2	1.0	0.5	1.420725	90.835000	181.67
4313	14204.0	2.0	2.0	2.000000	0.5	44.0	36.0	82.000000	1	0.0	0.0	2.405000	161.030000	161.03
4314	15471.0	2.0	2.0	2.000000	0.5	77.0	67.0	266.000000	1	0.0	0.0	1.999221	469.480000	469.48
4315	13436.0	1.0	1.0	1.000000	1.0	12.0	12.0	76.000000	1	0.0	0.0	5.830000	196.890000	196.89
4316	15520.0	1.0	1.0	1.000000	1.0	18.0	18.0	314.000000	1	0.0	0.0	1.724444	343.500000	343.50
4317	13298.0	1.0	1.0	1.000000	1.0	2.0	2.0	96.000000	1	0.0	0.0	3.750000	360.000000	360.00
4318	14569.0	1.0	1.0	1.000000	1.0	12.0	10.0	79.000000	1	0.0	0.0	3.920000	227.390000	227.39
4319	12713.0	0.0	0.0	0.000000	0.0	37.0	37.0	505.000000	1	0.0	0.0	2.084595	794.550000	794.55

Overview

Variables

Interactions

Correlations

Missing values

Sample